MySQL data types
The following table shows the MySQL source data types that are supported when using Qlik Compose and the default mapping to Qlik Compose data types.
For information on how to view the data type that is mapped in the data warehouse, see the section for the data warehouse database you are using.
|
MySQL data types |
Qlik Compose data types |
|---|---|
|
BIGINT |
Bigint |
|
binary |
BYTE |
|
bit |
bigint |
|
char |
Varchar |
|
date |
Date |
|
datetime |
Date |
|
DECIMAL |
Decimal |
|
double |
Decimal(38,12) |
|
ENUM('x-small', 'small', 'medium', 'large', 'x-large') |
Varchar(7) |
|
FLOAT |
Decimal(38,12) |
|
int |
integer |
|
MEDIUMINT |
integer |
|
MEDIUMTEXT |
Varchar(16777215) |
|
nchar(36) |
Varchar(36) |
|
NUMERIC |
Decimal |
|
REAL |
Decimal(38,12) |
|
set('a','b','c','d') |
Varchar(7) |
|
SMALLINT |
integer |
|
TEXT |
Varchar(65535) |
|
time |
Date |
|
timestamp |
Date |
|
TINYINT |
integer |
|
TINYTEXT |
Varchar(255) |
|
year |
integer |